Your step-by-step guide to doing more with Microsoft Excel Fully updated for the latest version of Office 365, Excel VBA Programming For Dummies will take your Excel knowledge to the next level. With a little background in Visual Basic for Applications (VBA) programming, you can go well beyond basic spreadsheets and functions. Learn the coding basics and syntax you need to write simple or complex macros that can automate your routine Excel tasks. Become an Excel power user by automating data management, user forms, pivot tables, and beyond. When you use VBA to perform Excel operations, you can reduce errors, save time, and integrate with other Microsoft applications. This handy guide also teaches you how to control the security settings for your macros and save macros to use across files.